package DBLayer;

import java.sql.Timestamp;
import java.util.ArrayList;

import ModelLayer.RentalPayment;

public interface IFDBRentalPayment {
	
	public int insert(RentalPayment rp);
	public int insert(Timestamp date, double amount, int apartId, int tenantId);
	public int update(RentalPayment rp);
	public int delete(int paymentID);	
	public RentalPayment getRentalPaymentById(int paymentID);
	public ArrayList<RentalPayment> getAll();
	public ArrayList<RentalPayment> getAll_where(String wClause);
	public ArrayList<RentalPayment> searchRandom(String searchF);
	public RentalPayment getRentalPayment_byDateAndApartment(int apartId, Timestamp date);
	double getReceivable();
	double getCommissionThisMonth();
	double getCommissionLastMonth();
}
